<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
	<head>
		<title></title>
		<meta name="GENERATOR" content="Microsoft Visual Studio .NET 7.1">
		<meta name="ProgId" content="VisualStudio.HTML">
		<meta name="Originator" content="Microsoft Visual Studio .NET 7.1">
	</head>
	<body>
		<H1><A name="_information_schema.domain_constraints"></A>DOMAIN_CONSTRAINTS</H1>
		<P>Contains one row for each user-defined data type, accessible to the current user 
			in the current database, with a rule bound to it. The <B>INFORMATION_SCHEMA.DOMAIN_CONSTRAINTS</B>
			view is based on the <B>sysobjects</B> and <B>systypes</B> system tables.</P>
		<P>To retrieve information from these views, specify the fully qualified name of <B>INFORMATION_SCHEMA</B><I>
				view_name</I>.</P>
		<TABLE id="Table1" cols="3" cellPadding="2" rules="all" width="587" border="1" frame="box">
			<TR vAlign="top">
				<TH class="label" width="35%">
					Column name</TH>
				<TH class="label" width="24%">
					Data type</TH>
				<TH class="label" width="41%">
					Description</TH></TR>
			<TR vAlign="top">
				<TD width="35%"><B>CONSTRAINT_CATALOG</B></TD>
				<TD width="24%"><B>nvarchar(128)</B></TD>
				<TD width="41%">Database in which the rule exists.</TD>
			</TR>
			<TR vAlign="top">
				<TD width="35%"><B>CONSTRAINT_SCHEMA</B></TD>
				<TD width="24%"><B>nvarchar(128)</B></TD>
				<TD width="41%">Rule owner.</TD>
			</TR>
			<TR vAlign="top">
				<TD width="35%"><B>CONSTRAINT_NAME</B></TD>
				<TD width="24%"><B>sysname</B></TD>
				<TD width="41%">Rule name.</TD>
			</TR>
			<TR vAlign="top">
				<TD width="35%"><B>DOMAIN_CATALOG</B></TD>
				<TD width="24%"><B>nvarchar(128)</B></TD>
				<TD width="41%">Database in which the user-defined data type exists.
				</TD>
			</TR>
			<TR vAlign="top">
				<TD width="35%"><B>DOMAIN_SCHEMA</B></TD>
				<TD width="24%"><B>nvarchar(128)</B></TD>
				<TD width="41%">User that created the user-defined data type.</TD>
			</TR>
			<TR vAlign="top">
				<TD width="35%"><B>DOMAIN_NAME</B></TD>
				<TD width="24%"><B>sysname</B></TD>
				<TD width="41%">User-defined data type.</TD>
			</TR>
			<TR vAlign="top">
				<TD width="35%"><B>IS_DEFERRABLE</B></TD>
				<TD width="24%"><B>varchar(2)</B></TD>
				<TD width="41%">Specifies whether constraint checking is deferrable. Always returns 
					NO.</TD>
			</TR>
			<TR vAlign="top">
				<TD width="35%"><B>INITIALLY_DEFERRED</B></TD>
				<TD width="24%"><B>varchar(2)</B></TD>
				<TD width="41%">
				Specifies whether constraint checking is initially deferred. Always returns NO.</TR>
		</TABLE>
	</body>
</html>
